create procedure [dbo].[BAEEventGetGuests] @RegistrantID varchar(16),
     @EventCode varchar(16) as
SELECT eg.EventGuestID, eg.RegistrantID, eg.EventCode, eg.GuestBadge, p.TITLE AS 'GuestBadgeTitle', eg.FirstName, eg.MiddleInitial, eg.LastName, eg.Address1, eg.City, eg.StateProvince, eg.PostalCode, cef.Price
    FROM CartEventFunction AS cef, EventGuest AS eg
    INNER JOIN Product AS p ON p.PRODUCT_CODE COLLATE database_default = eg.GuestBadge COLLATE database_default
    WHERE eg.RegistrantID = @RegistrantID AND eg.EventCode = @EventCode AND cef.CartEventFunctionID = eg.CartEventFunctionID;

GO